package com.foreveredu.propms.service;

import java.util.List;
import java.util.Map;
import com.foreveredu.propms.domain.District;
import com.foreveredu.propms.domain.PageModel;
import com.foreveredu.propms.domain.SubDistrict;

public interface IPropQueryService {

	//查询当前小区某年某月的物业费收费汇总
	Map<String, Object> querySubMonthlyCharge(SubDistrict sub, int year, int month);
	
	//查询当前小区某年某月的物业费收费汇总
	Map<String, Object> querySubMonthlyChargeYear(SubDistrict sub, int year);
   
	//查询当前小区某年某月的物业费收缴率(已缴费房产数/总房产数)
	public Map<String, Object> querySubPaidRate(SubDistrict sub, int year, int month);
	//根据小区处查询所有用户
	public PageModel queryUserBySub(SubDistrict sub, int year, int month,int offset);
	
	//查询当前物业服务处某年某月的物业费汇总
	Map<String, Object> queryDistMonthlyCharge(District district,int year, int month);
	
	//查询当前物业服务处某年的物业费汇总
	Map<String, Object> queryDistYearCharge(District district,int year);

	List<Map<String, Object>> queryIndividualChargeIntoExcel(SubDistrict sub, int year, int month,int chargeItemId);
	
	//查询当前小区某年某月的业主欠费汇总
	public PageModel  queryOweCollectCharge(int offset, SubDistrict sub, int year, int month);

	public PageModel findAllOweCharge(int offset, int year,int month);
	
	public PageModel findAllOwdCollectChargeList(int offset, int year,int month);
	public PageModel  findOwdCollectChargeBySubList(int offset, SubDistrict sub, int year, int month);
	
	public PageModel queryIndividualCharge(SubDistrict sub, int year, int month,int offset,int chargeItemId);

	List<Map<String, Object>> findAllOweCharge(int year, int month);

	List<Map<String, Object>> queryOweCollectCharge(
			SubDistrict findSubDistrictById, int year, int month);

	List<Map<String, Object>> findAllOwdCollectChargeList(int year, int month);

	List<Map<String, Object>> findOwdCollectChargeBySubList(SubDistrict sub,
			int year, int month);

	List<Map<String, Object>> doQueryownerChargeToExcel(SubDistrict sub,
			int year, int month);
}
